USE [Capstone]
GO

/****** Object:  StoredProcedure [dbo].[SystemDefault_Exists]    Script Date: 07/22/2012 22:49:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

  
-- =============================================  
-- Author:  Peter Gamble  
-- Create date: 04/08/2009  
-- Description: Return Bit - Username Exists?  
-- =============================================  
Create PROCEDURE [dbo].[SystemDefault_Exists]   
 -- Add the parameters for the stored procedure here  
@eFieldName varchar(200)  
AS  
BEGIN  
 -- SET NOCOUNT ON added to prevent extra result sets from  
 -- interfering with SELECT statements.  
 SET NOCOUNT ON;  
Declare @iFieldName varchar(200), @Count int;  
SET @iFieldName  = @eFieldName;  
  
    -- Insert statements for procedure here  
 Select 
  @Count = Count(*) 
 from 
  SystemDefaultValues 
 where 
  Field_Name = @iFieldName;  
 
  Select cast(@Count as bit) as Default_Found 
END  
  
GO

